---
title: DB-CLL-CT-001 — Retrieve a code-table lookup list for dropdowns
summary: Retrieve a code-table lookup list for dropdowns
status: draft
owner: SAIF Case Management team
last_reviewed: 2026-08-21
library: SAIF.Business.Claim.Legal
reference_type: embedded
---

# DB-CLL-CT-001 — Retrieve a code-table lookup list for dropdowns

## Classification

| Field | Value |
|---|---|
| SQL ID | DB-CLL-CT-001 |
| Operation type | R |
| Execution method | Text |
| Database | Oracle (Case Management) |
| Schema | [unqualified]** |
| Command type | Inline text SQL |
| Business object | mdlCodeTables |
| Criteria property | n/a (application-layer) |
| Lifecycle method | n/a |

## Parameters

No bound parameters were identified for this statement.

## Tables

| Table | Access | Columns/Notes |
|---|---|---|
| [CODE_TABLES](../database-tables.md#code-table-lookup-pattern) | SELECT | CODE, CODE_DESCR (generic pattern applied to ~21 code tables) |
| [ADP_EMPLOYEE](../database-tables.md#adp_employee) | SELECT | joined for employee-name lookups |
| [ATTORNEY_PROFILE](../database-tables.md#code-table-lookup-pattern) | SELECT | joined for attorney lookups |
| [LEGAL_PERSON](../database-tables.md#legal_person) | SELECT | joined for legal-person lookups |
| [OTHER_FIRM](../database-tables.md#other_firm) | SELECT | joined for firm lookups |
| [HEARING_LOCATION](../database-tables.md#hearing_location) | SELECT | joined for hearing-location lookups |

## Sample SQL

```sql
Select
  CODE,
  CODE_DESCR
From
  {CODE_TABLE_NAME}
Order by
  CODE
```

## Operations and processes

- [Resolve code-table lookups](../operations/resolve-code-table-lookups.md)

## Sources

- `SAIF.Business.Claim.Legal\mdlCodeTables.vb`